package com.xbongbong.pro.bi.commons.constant;


/**
 * @author gzt
 * @version 1.0
 * @Description -
 * @datetime - 2022/5/18-10:24
 * @since v1.0
 */
public class Constant {
    /**
     * SQL 中 select 关键字
     */
    public static final String SELECT = "SELECT" ;

    /**
     * FROM DUAL 关键字
     */
    public static final String FROM_DUAL = "FROM DUAL" ;
    /**
     * tab 制表符
     */
    public static final String TAB = "\t" ;
    /**
     * UNION ALL 关键字
     */
    public static final String UNION_ALL = "UNION ALL" ;
    /**
     * SQL 中 AS 关键字
     */
    public static final String AS = "AS" ;
    /**
     * quotes 单引号
     */
    public static final String QUOTES = "'";


    public static final String SPACE = " ";
    public static final String UPDATE = "UPDATE";
    public static final String DELETE_FROM = "DELETE FROM";
    public static final String INSERT_INTO = "INSERT INTO";
    public static final String VALUES = "VALUES";
    public static final String SET = "SET";
    public static final String FROM = "FROM";
    public static final String WHERE = "WHERE";
    public static final String AND = "AND";
    public static final String OR = "OR";
    public static final String INNER_JOIN = "INNER JOIN";
    public static final String LEFT_JOIN = "LEFT JOIN";
    public static final String RIGHT_JOIN = "RIGHT JOIN";
    public static final String FULL_JOIN = "FULL JOIN";
    public static final String ON = "ON";
    public static final String ORDER_BY = "ORDER BY";
    public static final String GROUP_BY = "GROUP BY";
    public static final String HAVING = "HAVING";
    public static final String ASC = "ASC";
    public static final String DESC = "DESC";
    public static final String UNION = "UNION";
    public static final String LIMIT = "LIMIT";
    public static final String OFFSET = "OFFSET";
    /* sql中前缀常量 */
    public static final String EMPTY = "";
    public static final String ONE_SPACE = " ";
    public static final String AND_PREFIX = " AND ";
    public static final String OR_PREFIX = " OR ";
    /* sql中的后缀常量 */
    public static final String EQUAL_SUFFIX = " = ? ";
    public static final String EQUAL = " = ";
    public static final String GT_SUFFIX = " > ? ";
    public static final String LT_SUFFIX = " < ? ";
    public static final String GTE_SUFFIX = " >= ? ";
    public static final String LTE_SUFFIX = " <= ? ";
    public static final String NOT_EQUAL_SUFFIX = " <> ? ";
    public static final String LIKE_KEY = " LIKE ";
    public static final String NOT_LIKE_KEY = " NOT LIKE ";
    public static final String BT_AND_SUFFIX = " BETWEEN ? AND ? ";
    public static final String IN_SUFFIX = " IN ";
    public static final String NOT_IN_SUFFIX = " NOT IN ";
    public static final String IS_NULL_SUFFIX = " IS NULL ";
    public static final String IS_NOT_NULL_SUFFIX = " IS NOT NULL ";

    /* 集合类型的常量,0表示单个对象，1表示普通数组，2表示Java集合 */
    public static final int OBJTYPE_ARRAY = 1;
    public static final int OBJTYPE_COLLECTION = 2;

    //新工单自定义报表 常量
    public static final Long nodeLogInfoFormId = 0L;

}
